package internationalenergytradingplatform.dao;

import internationalenergytradingplatform.pojo.Classification;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ClassificationDao {
    /**
     *
     * @author yingfeng
     * @date 2024/3/12 14:53
     展示某个供应商的所有类别
     */
    @Select("select * from commodity_classification where accountr = #{tele}")
    public List<Classification> getAllClassificationByTele(String tele);

    /**
     *
     * @author yingfeng
     * @date 2024/3/12 14:53
    展示所有类别
     */
    @Select("select * from commodity_classification")
    List<Classification> getAllClassification();
}
